<%-- 
    Document   : AddVip
    Created on : 2014/2/26, 上午 09:51:12
    Author     : Gjun
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%  
    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
    java.sql.Connection con = java.sql.DriverManager.getConnection(
        "jdbc:sqlserver://10.10.2.171:1433;databaseName=javadb", "javadb", "javadb");
    String sql="select * from account_test_only";  //在公務上千萬不要用*!!!乖乖打欄位 !!!切記!!!
    java.sql.Statement st = con.createStatement();
    java.sql.ResultSet rs =st.executeQuery(sql);
     
%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
        <style type="text/css">
        #Gay {
            width: 900px;
            border-collapse: collapse;
        }
        #Gay td {
                padding: 10px;
                text-align: center;
            }
    </style>

    </head>
    <body>
        <form action="<%= response.encodeURL("AddVipOk.jsp") %>" method="post">
         <h2>填寫會員資料</h2>
 
    <table id="Gay">
        <thead>
            <tr>
                <td>帳號：</td>
                <td>
                    <input id="login_account" name="login_account" type="text" value="" />
                </td>
                <td></td>
                <td>&nbsp;</td>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td>密碼：</td>
                <td>
                    <input id="login_password" name="login_password" type="password" value="" />
                </td>
                <td></td>
                <td>&nbsp;</td>
                <td></td>
            </tr>
            <tr>
                <td>確認密碼：</td>
                <td>
                    <input id="confirm_login_password" type="password" value="" />
                </td>
                <td></td>
                <td></td>
                <td></td>
            </tr>
            <tr>
                <td>姓名：</td>
                <td>
                    <input id="user_name" name="user_name" type="text" value="" />
                </td>
                <td></td>
                <td></td>
                <td></td>
            </tr>
            <tr>
                <td>性別：</td>
                <td>
                    <input id="maleSex" name="sex" type="radio" value="男生" />男生
                        <input id="femaleSex" name="sex" type="radio" value="女生" />女生
                </td>
                <td></td>
                <td>&nbsp;</td>
                <td></td>
            </tr>
            <tr>
                <td>生日：</td>
                <td>年：<select id="birth_year" name="birth_year">
                    <option>--請選擇--</option>
                <%
                    for(int i=1;i<=114;i++)
                    {                                          
                %>                                          
                <option value="<%=i%>"><%=1900+i%></option> 
                <%}%>  
                </select>
                </td>
                <td>月：<select id="birth_month" name="birth_year">
                    <option>--請選擇--</option>
                    <option value="1">一月</option> 
                    <option value="2">二月</option> 
                    <option value="3">三月</option> 
                    <option value="4">四月</option> 
                    <option value="5">五月</option> 
                    <option value="6">六月</option> 
                    <option value="7">七月</option> 
                    <option value="8">八月</option> 
                    <option value="9">九月</option> 
                    <option value="10">十月</option> 
                    <option value="11">十一月</option> 
                    <option value="12">十二月</option> 
                  
                </select>
                </td>
                
                <td>日：<select id="birth_day" name="birth_day">
                    <option>--請選擇--</option>
                <%
                    for(int i=0;i<=30;i++)
                    {                                          
                %>  
                    <option value="<%=i%>"><%=i+1%>日</option> 
                <%}%>            
                </select>
                </td>
                            
            </tr>
            <tr>
                <td>聯絡地址：</td>
                <td>縣市：<select id="county" name="county">
                    <option>--請選擇--</option>
                </select>
                </td>
                <td>鄉鎮市：<select id="region" name="region">
                    <option>--請選擇--</option>
                </select>
                </td>
            </tr>
            <tr>
                <td></td>
                <td>地址：<input id="address" name="address" type="text" value="" /></td>
                <td></td>
            </tr>
            <tr>
                <td>身分證號碼：</td>
                <td>
                    <input id="id_number" name="id_number" type="text" value="" /></td>
                <td></td>
            </tr>
            <tr>
                <td>電話手機：</td>
                <td>
                    <input id="phone" name="phone" type="text" value="" /></td>
                <td></td>
            </tr>
            <tr>
                <td>電子郵件：</td>
                <td>
                    <input id="email" name="email" type="text" value="" />
                </td>
                <td></td>
                <td></td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>驗證碼：</td>
                <td>
                    <input id="vaildNumText" name="vaildNumText" type="text" value="" /></td>
                <td>
                    <input id="changeVaildImgBtn" type="button" value="更換圖片" /></td>
                <td></td>
            </tr>
            <tr>
                <td></td>
                <td>
                    <input id="Submit1" type="submit" value="加入會員" />
                    <input id="Reset1" type="reset" value="重新填寫" />
                </td>
                <td></td>
                <td></td>
            </tr>
        </tbody>
    </table>
    </form>
    </body>
</html>
